CREATE TABLE [dbo].[tb_TraslacionDeCargosYAsignaturas]
(
[IdTraslacion] [int] NOT NULL,
[Escalafon] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cargo] [int] NULL,
[DescripcionCargo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asignatura] [int] NULL,
[DescripcionAsignatura] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CargoDefinitivo] [int] NULL,
[AsignaturaDefinitiva] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_TraslacionDeCargosYAsignaturas] ADD CONSTRAINT [PK_tb_TraslacionDeCargosYAsignaturas] PRIMARY KEY NONCLUSTERED  ([IdTraslacion]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_TraslacionDeCargosYAsignaturas] WITH NOCHECK ADD CONSTRAINT [FK_tb_TraslacionDeCargosYAsignaturas_tb_AsignaturasGenericas] FOREIGN KEY ([AsignaturaDefinitiva]) REFERENCES [dbo].[tb_AsignaturasGenericas] ([idAsignaturaGenerica])
GO
ALTER TABLE [dbo].[tb_TraslacionDeCargosYAsignaturas] WITH NOCHECK ADD CONSTRAINT [FK_tb_TraslacionDeCargosYAsignaturas_tb_CargosGenericos] FOREIGN KEY ([CargoDefinitivo]) REFERENCES [dbo].[tb_CargosGenericos] ([idCargoGenerico])
GO
